Create Snowflake Warehouse

You can create a Snowflake warehouse as per your requirement from within the Lazsa Platform without logging on to the Snowflake account. Snowflake warehouse provides the required compute resources for executing SQL statements.

Prerequisites:

  • You must have tenant admin role in the Lazsa Platform.

  • You must have admin access to the Snowflake account on which you want to create the warehouse.

To create a Snowflake warehouse

  1. Log on to the Lazsa Platform and navigate to Configuration > Cloud Platform Tools and Technologies.

  2. Click Modify on Databases and Data Warehouses and then click Snowflake.

  3. On the Snowflake screen enter the following details:

Field Description
Name A name for the Snowflake account that you want to configure. After you configure the account, it is listed with this name on the Databases and Data Warehouses screen.
Description Additional information about the Snowflake account.
Account URL URL of the Snowflake account.
Username Username for accessing the Snowflake account.
Password Password for accessing the Snowflake account.
Click Test Connection to check if you are able to connect to the configured Snowflake account.
Database Select a database from the Snowflake account.
Schema Select the required schema from the Snowflake account.
Warehouse Either select an existing warehouse or create a new warehouse.
View Details (...)

  • Edit - edit the warehouse.

  • Resume/Suspend - Activate a suspended warehouse or suspend an activated warehouse.

  • Delete - delete the warehouse.

  1. To create a new warehouse, click Add New Warehouse.

  2. On the New Warehouse screen, provide the required information under each section and then click Save.

    1. Warehouse Details:

    Name Name of the warehouse can include alphanumeric and special characters like space, hyphen, and underscore but should not end with special characters.
    Size Size of the virtual warehouse.
    Auto Suspend Number of seconds of inactivity after which the warehouse is suspended automatically.
    Auto Resume Enable this option if you want the warehouse to be activated automatically whenever it receives a SQL query for processing. This option overrules the Auto Suspend setting.

    1. Cluster Properties:

    Max Cluster Count Maximum number of clusters for a multi-cluster warehouse.
    Min Cluster Count Minimum number of clusters for a multi-cluster warehouse.
    Scaling Policy Policy for automatically starting and shutting down clusters in a multi-cluster warehouse.
    Initially Suspended Specifies whether the cluster is created initially in a suspended state.
    Resource Monitor Specify the name of a resource monitor that is explicitly assigned to the warehouse.
    Enable Query Acceleration Specifies whether to enable query acceleration service that relies on this warehouse for compute resources.
    Query Acceleration Max Scale Factor Specify the maximum scale factor for leasing compute resources for query acceleration.

    1. Additional Parameters:

    Max Concurrency Level Parameter that specifies concurrency level for SQL statements executed by a warehouse cluster.
    Statement Queued Timeout in Seconds Parameter that specifies the time in seconds for which a SQL statement can be queued on a warehouse before it is canceled by the system.
    Tags Enabled Enable this option to use tags.

 

Related Topics Link IconRecommended Topics What's next? Snowflake Custom Transformation Job